<?php
/* -----------------------------------------------------------------
 *                        Aveghe My Blog
 * -----------------------------------------------------------------
 * Aveghe My Blog: made your blog easy!
 * Copyright (C) 2008 Elia Contini
 * 
 * Aveghe My Blog is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 * 
 * Aveghe My Blog is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
 * MA 02110-1301, USA.
 */

class Aveghe_SQLReader
	{
		private $queriesArray;
		
		function __construct($fileName, $tablePrefix = '')
			{
				$handler = fopen($fileName, 'r');
				$clearFile = '';
				
				while(!feof($handler))
					{
						$line = fgets($handler);
						
						if(!ereg('^--', $line) && ereg('[a-zA-Z0-9()]', $line))
							{
								// add table prefix to CREATE TABLE
								$line = str_replace('TABLE ', 'TABLE '.$tablePrefix, trim($line)."\n");
								
								// add table prefix to REFERENCES
								$line = str_replace('REFERENCES ', 'REFERENCES '.$tablePrefix, $line);
								
								$clearFile .= $line;
							}
					}
				fclose($handler);
				
				// removoving the last blank line (\n)
				$length = strlen($clearFile);
				$this->queriesArray = explode( ';', substr($clearFile, 0, ($length - 2)) );
			}
		
		public function getQueriesArray()
			{
				return $this->queriesArray;
			}
	}
?>